SLAM_sObject_fields
Downloads detailed field definitions for a single object. The results will be stored in a table sobject_fields_<sObjectName>
tip
When bulk retrieval of all fields for all objects from Salesforce org is not needed, this is the preferred method because this method is not limited by permissions.
- Fields named
part.*are not subject to permissions - Fields named
desc.*are subject to permissions and may be null
Parameters:
| Name | Type | Default | Description |
|---|---|---|---|
@sObject | VARCHAR(120) | Required | Salesforce object name to retrieve fields for |
@exists_action | VARCHAR(20) | NULL | Action to take if the destination object sobject_fields_<sObjectName> already exists. If NULL, uses the value from SLAM_Settings.default_exists_action (defaulted to 'drop' during initial setup).Valid options:
|
Usage Examples:
EXEC dbo.SLAM_sObject_fields 'Account'
SELECT * FROM sobject_fields_Account